/*
 Navicat Premium Data Transfer

 Source Server         : 172.16.24.150
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 172.16.24.150:3306
 Source Schema         : viewer

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 24/10/2020 12:36:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for position_type_info_v2
-- ----------------------------
DROP TABLE IF EXISTS `position_type_info_v2`;
CREATE TABLE `position_type_info_v2` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'key',
  `position_type_name` varchar(255) DEFAULT NULL COMMENT '职位分类名称',
  `position_type_code` varchar(50) DEFAULT NULL COMMENT '职位分类code',
  `position_num` int(11) DEFAULT NULL COMMENT '职位分类数量',
  `company_id` int(11) DEFAULT NULL COMMENT '企业ID',
  `company_code` varchar(255) DEFAULT NULL COMMENT '公司code',
  `company_jc` varchar(100) DEFAULT NULL COMMENT '公司简介',
  `status` char(5) DEFAULT NULL COMMENT '抓取状态',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '插入日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of position_type_info_v2
-- ----------------------------
BEGIN;
INSERT INTO `position_type_info_v2` VALUES (1, '生产制造', '03', 1, 1, '0001', 'localhouse私有云存储专家', '进行中', '2020-10-20 02:20:00');
INSERT INTO `position_type_info_v2` VALUES (2, '生产制造', '03', 100, 2, '002', '私有云存储专家', '进行中', '2020-10-24 02:20:07');
INSERT INTO `position_type_info_v2` VALUES (3, '生产制造', '03', 10, 3, '003', '私有云存储专家', '进行中', '2020-10-21 02:20:11');
INSERT INTO `position_type_info_v2` VALUES (4, '销售', '04', 11, 4, '004', '私有云存储专家', '进行中', '2020-10-22 02:20:29');
INSERT INTO `position_type_info_v2` VALUES (5, '销售', '04', 12, 5, '005', '私有云存储专家', '进行中', '2020-10-23 02:20:37');
INSERT INTO `position_type_info_v2` VALUES (6, '销售', '04', 15, 6, '006', '私有云存储专家', '进行中', '2020-10-21 00:00:00');
INSERT INTO `position_type_info_v2` VALUES (7, '销售', '04', 12, 1, '001', '私有云存储专家', '进行中', '2020-10-24 02:20:46');
INSERT INTO `position_type_info_v2` VALUES (8, '服务业', '05', 11, 2, '002', '私有云存储专家', '进行中', '2020-10-22 02:29:57');
INSERT INTO `position_type_info_v2` VALUES (9, '服务业', '05', 16, 3, '003', '私有云存储专家', '进行中', '2020-10-20 02:30:07');
INSERT INTO `position_type_info_v2` VALUES (10, '服务业', '05', 16, 4, '004', '私有云存储专家', '进行中', '2020-10-23 02:30:11');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
